/*
 * Package : com.spi.soconversion
 * Created by: Software Paradigms International Group, LLC. (SPI) 
 * Copyright (c) 2010 HBC
 */

package com.spi.soconversion.util;

/**
 * This class provides constants used in Sales Order Conversion Application.
 * <p>
 * Issues:
 * <p>
 * NONE
 * <p>
 * History:
 * <p>
 * <ul>
 * <li>2010.04.17 pk: created
 * </ul>
 *
 * @author Priya Khanna, SPI (pk)
 */

public class SOCConstants {

	/**
	 * Constant indicates the install base module
	 */
	public final static int SOC_INSTALL_BASE = 0;

	/**
	 * Constant indicates the install base module
	 */
	public final static int SOC_OPEN_SALES_ORDER = 1;
	
	/**
	 * Constant indicates the install base module
	 */
	public final static int SOC_CLOSED_SALES_ORDER = 2;
	
	/**
	 * Constant indicates the install base module
	 */
	public final static int SOC_TENDERING_TABLES = 3;	
	
	/**
     * Constant indicates delimiter of file system
     */
    public static final char DELIMITER = 
        System.getProperty("file.separator").charAt(0);    
    
    /**
     * Constant indicates equals
     */
    public static final String EQUALS = "=";
    
    /**
     * Constant indicates Bay
     */
    public static final String BAY = "BAY";
    
    /**
     * Constant indicates Batch
     */
    public static final String BATCH = "BATCH";
    
    /**
     * Constant indicates zero
     */
    public static final String ZERO = "0";    
    
    /**
     * Constant indicates double quote
     */
    public static final String DOUBLE_QUOTE = "\"";
    
    /**
     * Constant indicates hyphen
     */
    public static final String HYPHEN = "-";
    
    /**
	 * Constant indicates blank string
	 */
	public static final String BLANK_STRING = " ";
	
    /**
	 * Constant indicates empty string
	 */
	public static final String EMPTY_STRING = "";
	
	 /**
     * Constant indicates equals
     */
    public static final String COMMA = ",";    
	  
    /**
	 * Constant indicates new line
	 */
	public static final String NEW_LINE = "\r\n";
	
	/**
	 * Constant indicates backslash
	 */
	public static final String BACKSLASH = "\b";
	
	/**
	 * Constant indicates dot
	 */
	public static final String DOT = ".";
	
	/**
	 * Constant indicates Underscore
	 */
	public static final String UNDERSCORE = "_";
	
	/**
	 * Constant indicates colon
	 */
	public static final String COLON = ":";
	
	/**
	 * Constant indicates default expectancy
	 */
	public static final String DEFAULT_LIFEEXPECTANCY = "3650";
	
	/**
	 * Constant indicates number of days in years
	 */
	public static final int DAYS_IN_YEAR = 365;
	
	/**
	 * Constant indicates database host
	 */
	public static final String DATABASE_HOST = "jdbc:oracle:thin:@";
	
	/**
	 * Constant indicates oracle driver class name
	 */
	public static final String ORACLE_DRIVER_CLASSNAME = "oracle.jdbc.driver.OracleDriver";
		
	/**
	 * Constant indicates message that Install Base Conversion can't be performed 
	 */
	public static final String CONVERSION_NOT_PERFORM_INSTALL_BASE= "Cannot Perform XML Generation for Install Base Conversion.";
		
	/**
	 * Constant indicates xml file reader
	 */
	public static final String XML_FILE_HEADER ="<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
    
	/**
	 * Constant indicates closing xml tag
	 */
	public static final String CLOSING_XML_TAG = ">";
	
	/**
	 * Constant indicates Closed Sales Order Log File Name
	 */
	public static final String CLOSED_SALES_ORDER_LOG_FILE = "convertedClosedSalesOrder";
	
	public static final String OPEN_SALES_ORDER_LOG_FILE = "convertedOpenSalesOrder";
	
	/**
	 * Constant indicates Closed Sales Order XML File Name
	 */
	public static final String CLOSED_SALES_ORDER_XML_FILE = "convertedClosedSalesOrder_";
	
	public static final String OPEN_SALES_ORDER_XML_FILE = "convertedOpenSalesOrder_";
	
	/**
	 * Constant indicates Install Base XML File Name
	 */
	public static final String INSTALL_BASE_XML_FILE = "convertedInstallBase_";
	
	/**
	 * Constant indicates Install Base Log File Name
	 */
	public static final String INSTALL_BASE_LOG_FILE = "convertedInstallBase";
	
	/**
	 * Constant indicates Execution Summary File Name
	 */
	public static final String EXECUTION_SUMMARY_FILE = "execution_summary_";
	
	/**
	 * Constant indicates Log File Name extn
	 */
	public static final String LOG_FILE_EXTN=".txt";
	
	/**
	 * Constant indicates XML File Name extn
	 */
	public static final String XML_FILE_EXTN=".xml";
	
	/**
	 * Constant indicates item type for warranty install base
	 */
	public static final String ITEM_TYPE_WARRANTY="PROD";
	
	/**
	 * Constant indicates line type for warranty install base
	 */
	public static final String LINE_TYPE_WARRANTY="Warranty";
	
	public static final String LINE_TYPE_DEL = "DEL";
	
	public static final String LINE_TYPE_WTY = "WTY";
	
	public static final String LINE_TYPE_USE = "USE";
	
	public static final String LINE_TYPE_WRFEE = "WRFEE";
	
	public static final String LINE_TYPE_EFEE = "EFEE";
	
	public static final String LINE_TYPE_ALL = "ALL";
	
	/**
	 * Constant indicates default shipping method for install base
	 */
	public static final String DEFAULT_SHIPPING_METHOD_INSTALL_BASE="000001_Home Deliv_T_GND";
	
	/**
	 * Constant indicates default shipping method for closed sales
	 */
	public static final String DEFAULT_SHIPPING_METHOD_CLOSED_SALES="000001_Customer_P_CARRY";
	
	/**
	 * Constant indicates message when closed sales order conversion starts
	 */
	public static final String MESSAGE_CONVERSION_STARTED_CLOSED_SALES_ORDER="Conversion for Closed Sales Order Starts";
	
	/**
	 * Constant indicates message when populating table FLATTABLE_CLOSED_SALES_ORDER starts
	 */
	public static final String MESSAGE_POPULATION_FLATTABLE_CLOSED_SALES_ORDER_STARTS="Started populating table FLATTABLE_CLOSED_SALES_ORDER";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_INFO starts
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_INFO_STARTS="Started populating master table TBL_STAGING_INSTALL_BASE_INFO";
		
	/**
	 * Constant indicates message when populating table TBL_STG_OPEN_ORDER_LINES starts
	 */
	public static final String MESSAGE_POPULATION_TBL_STG_OPEN_ORDER_LINES_STARTS="Started populating master table TBL_STG_OPEN_ORDER_LINES";

	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_ADDR starts
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_ADDR_STARTS="Started populating table TBL_STAGING_INSTALL_BASE_ADDR";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_CONT starts
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_CONT_STARTS="Started populating table TBL_STAGING_INSTALL_BASE_CONT";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_NOTES starts
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_NOTES_STARTS="Started populating table TBL_STAGING_INSTALL_BASE_NOTES";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_WTY starts
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_WTY_STARTS="Started populating table TBL_STAGING_INSTALL_BASE_WTY";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_INFO starts
	 */
	public static final String MESSAGE_ANALYZE_INSTALL_BASE_STARTS="Started analyzing table TBL_STAGING_INSTALL_BASE_INFO";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_ADDR starts
	 */
	public static final String MESSAGE_ANALYZE_ADDRESS_INSTALL_BASE_STARTS="Started analyzing table TBL_STAGING_INSTALL_BASE_ADDR";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_CONT starts
	 */
	public static final String MESSAGE_ANALYZE_CONTACTS_INSTALL_BASE_STARTS="Started analyzing table TBL_STAGING_INSTALL_BASE_CONT";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_NOTES starts
	 */
	public static final String MESSAGE_ANALYZE_NOTES_INSTALL_BASE_STARTS="Started analyzing table TBL_STAGING_INSTALL_BASE_NOTES";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_WTY starts
	 */
	public static final String MESSAGE_ANALYZE_WARRANTY_INSTALL_BASE_STARTS="Started analyzing table TBL_STAGING_INSTALL_BASE_WTY";
		
	/**
	 * Constant indicates message when populating table FLATTABLE_CLOSED_SALES_ORDER ends
	 */
	public static final String MESSAGE_POPULATION_FLATTABLE_CLOSED_SALES_ORDER_ENDS="Completed populating table FLATTABLE_CLOSED_SALES_ORDER";
	
	/**
	 * Constant indicates message when populating table TBL_STG_OPEN_ORDER_LINES ends
	 */
	public static final String MESSAGE_POPULATION_TBL_STG_OPEN_ORDER_LINES_ENDS="Completed populating table TBL_STG_OPEN_ORDER_LINES with records - ";

	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_INFO ends
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_INFO_ENDS="Completed populating table TBL_STAGING_INSTALL_BASE_INFO with records - ";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_ADDR ends
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_ADDR_ENDS="Completed populating table TBL_STAGING_INSTALL_BASE_ADDR with records - ";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_NOTES ends
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_CONT_ENDS="Completed populating table TBL_STAGING_INSTALL_BASE_CONT with records - ";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_NOTES ends
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_NOTES_ENDS="Completed populating table TBL_STAGING_INSTALL_BASE_NOTES with records - ";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_INSTALL_BASE_WTY ends
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_INSTALL_BASE_WTY_ENDS="Completed populating table TBL_STAGING_INSTALL_BASE_WTY with records - ";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_INFO ends
	 */
	public static final String MESSAGE_ANALYZE_INSTALL_BASE_ENDS="Completed analyzing table TBL_STAGING_INSTALL_BASE_INFO";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_ADDR ends
	 */
	public static final String MESSAGE_ANALYZE_ADDRESS_INSTALL_BASE_ENDS="Completed analyzing table TBL_STAGING_INSTALL_BASE_ADDR";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_CONT ends
	 */
	public static final String MESSAGE_ANALYZE_CONTACTS_INSTALL_BASE_ENDS="Completed analyzing table TBL_STAGING_INSTALL_BASE_CONT";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_NOTES ends
	 */
	public static final String MESSAGE_ANALYZE_NOTES_INSTALL_BASE_ENDS="Completed analyzing table TBL_STAGING_INSTALL_BASE_NOTES";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_INSTALL_BASE_WTY ends
	 */
	public static final String MESSAGE_ANALYZE_WARRANTY_INSTALL_BASE_ENDS="Completed analyzing table TBL_STAGING_INSTALL_BASE_WTY";
		
	/**
	 * Constant indicates message when updating table TBL_INSTALLBASE_ERRORS starts
	 */
	public static final String MESSAGE_PROCESSING_OSO_ERROR_STARTS="Started updating install base error messages to TBL_OPEN_SALES_ORDER_ERRORS";

	/**
	 * Constant indicates message that the XML validator started processing
	 */
	public static final String XML_VALIDATOR_STARTED_PROCESSING="Started XML validation against XSD";
	
	/**
	 * Constant indicates message that the XML validator ended processing
	 */
	public static final String XML_VALIDATOR_ENDED_PROCESSING="Completed XML validation against XSD";
	
	/**
	 * Constant indicates directory name for good xml files
	 */
	public static final String DIR_NAME_GOOD_RECORDS="GoodRecords";
	
	/**
	 * Constant indicates directory name for bad xml files
	 */
	public static final String DIR_NAME_BAD_RECORDS="BadRecords";
	
	/**
	 * Constant indicates xml schema
	 */
	public static final String XML_SCHEMA="http://www.w3.org/2001/XMLSchema";
	
	/**
	 * Constant indicates install base XSD
	 */
	public static final String INSTALLBASE_XSD="InstallBaseSchema.xsd";
	
	/**
	 * Constant indicates message when retrieving batch number from CONVERSION_BATCH_RECORDS starts
	 */
	public static final String MESSAGE_RETRIEVE_BATCH_NUMBER_STARTS="Started getting last batch number run from table CONVERSION_BATCH_RECORDS";
	
	/**
	 * Constant indicates message when retrieving batch number from CONVERSION_BATCH_RECORDS ends
	 */
	public static final String MESSAGE_RETRIEVE_BATCH_NUMBER_ENDS="Completed getting last batch number run from table CONVERSION_BATCH_RECORDS";
	
	/**
	 * Constant indicates message when retrieving total records processed till last run from CONVERSION_BATCH_RECORDS starts
	 */
	public static final String MESSAGE_RETRIEVE_TOTAL_RECORDS_PROCESSED_STARTS="Started getting total records processed till last run from table CONVERSION_BATCH_RECORDS";
	
	/**
	 * Constant indicates message when retrieving total records processed till last run from CONVERSION_BATCH_RECORDS ends
	 */
	public static final String MESSAGE_RETRIEVE_TOTAL_RECORDS_PROCESSED_ENDS="Completed getting total records processed till last run from table CONVERSION_BATCH_RECORDS";
	
	/**
	 * Constant indicates message when deleting existing files under good xml directory
	 */
	public static final String MESSAGE_GOOD_XML_DIRECTORY_CONTENTS_DELETED="All files already existing under good xml directory are deleted along with the directory - ";
	
	/**
	 * Constant indicates message when deleting existing files under bad xml directory
	 */
	public static final String MESSAGE_BAD_XML_DIRECTORY_CONTENTS_DELETED="All files already existing under bad xml directory are deleted along with the directory - ";
	
	/**
	 * Constant indicates message when retrieving total records to be processed from TBL_STAGING_INSTALL_BASE_INFO starts
	 */
	public static final String MESSAGE_RETRIEVE_TOTAL_RECORDS_TO_BE_PROCESSED_STARTS="Started getting total records to be converted from TBL_STAGING_INSTALL_BASE_INFO";
	
	/**
	 * Constant indicates message when retrieving total records to be processed from TBL_STAGING_INSTALL_BASE_INFO ends
	 */
	public static final String MESSAGE_RETRIEVE_TOTAL_RECORDS_TO_BE_PROCESSED_ENDS="Completed getting total records to be converted from TBL_STAGING_INSTALL_BASE_INFO";

	
	/**
	 * Constant indicates message when retrieving total records to be processed from TBL_STG_OPEN_ORDER_LINES starts
	 */
	public static final String MESSAGE_RETRIEVE_TOTAL_RECORDS_TO_BE_PROCESSED_STARTS_OSO="Started getting total records to be converted from TBL_STG_OPEN_ORDER_LINES";
	
	/**
	 * Constant indicates message when retrieving total records to be processed from TBL_STG_OPEN_ORDER_LINES ends
	 */
	public static final String MESSAGE_RETRIEVE_TOTAL_RECORDS_TO_BE_PROCESSED_ENDS_OSO="Completed getting total records to be converted from TBL_STG_OPEN_ORDER_LINES";

	/**
	 * Constant indicates message when processing table TBL_STAGING_INSTALL_BASE_INFO starts
	 */
	public static final String MESSAGE_PROCESSING_INSTALL_BASE_STARTS="Started processing install base records from TBL_STAGING_INSTALL_BASE_INFO";
		
	/**
	 * Constant indicates message when processing table TBL_STAGING_INSTALL_BASE_INFO ends
	 */
	public static final String MESSAGE_PROCESSING_INSTALL_BASE_ENDS="Completed processing install base records from  TBL_STAGING_INSTALL_BASE_INFO";
	
	/**
	 * Constant indicates message when updating table TBL_INSTALLBASE_ERRORS starts
	 */
	public static final String MESSAGE_PROCESSING_INSTALL_BASE_ERROR_STARTS="Started updating install base error messages to TBL_INSTALLBASE_ERRORS";
		
	/**
	 * Constant indicates message when updating table TBL_INSTALLBASE_ERRORS ends
	 */
	public static final String MESSAGE_PROCESSING_INSTALL_BASE_ERROR_ENDS="Completed updating install base error messages to TBL_INSTALLBASE_ERRORS";
	
	/**
	 * Constant indicates message to display total number of records converted
	 */
	public static final String MESSAGE_TOTAL_RECORDS_CONVERTED="Total Number of Records considered for conversion = ";
	
	/**
	 * Constant indicates message to display total number of orders converted
	 */
	public static final String MESSAGE_TOTAL_ORDERS_CONVERTED="Total Number of Orders considered for conversion = ";
	
	/**
	 * Constant indicates message to display total number of records converted to xmls successfully
	 */
	public static final String MESSAGE_TOTAL_RECORDS_CONVERTED_TO_XMLS_SUCCESSFULLY="Total Number of Records converted successfully into XMLs = ";
	
	/**
	 * Constant indicates message to display total number of orders converted to xmls successfully
	 */
	public static final String MESSAGE_TOTAL_ORDERS_CONVERTED_TO_XMLS_SUCCESSFULLY="Total Number of Orders converted successfully into XMLs = ";
	
	/**
	 * Constant indicates message to display total number of xmls passed valdiation
	 */
	public static final String MESSAGE_TOTAL_XMLS_PASSED_VALIDATION="Total Number of Records passed XML validation = ";
	
	/**
	 * Constant indicates message to display total number of orders xmls passed valdiation
	 */
	public static final String MESSAGE_TOTAL_ORDERS_XMLS_PASSED_VALIDATION="Total Number of Orders passed XML validation = ";

	/**
	 * Constant indicates message to batch number
	 */
	public static final String MESSAGE_BATCH_NUMBER="Batch Number = ";
	
	/**
	 * Constant indicates message to display number of records processed in this batch
	 */
	public static final String MESSAGE_TOTAL_RECORDS_PROCESSED_BATCH="Total Number of Records processed in present batch = ";
	
	/**
	 * Constant indicates message to display number of orders processed in this batch
	 */
	public static final String MESSAGE_TOTAL_ORDERS_PROCESSED_BATCH="Total Number of Orders processed in present batch = ";
	
	/**
	 * Constant indicates message to display number of records processed till this batch
	 */
	public static final String MESSAGE_TOTAL_RECORDS_PROCESSED_TILL_BATCH="Total Number of Records processed till present batch = ";
	
	/**
	 * Constant indicates message to display number of Orders processed till this batch
	 */
	public static final String MESSAGE_TOTAL_ORDERS_PROCESSED_TILL_BATCH="Total Number of Orders processed till present batch = ";
	
	/**
	 * Constant indicates message to display number of records 	with data issues in this batch
	 */
	public static final String MESSAGE_TOTAL_RECORDS_DATA_ISSUES_BATCH="Total Number of Records with data issues in present batch = ";
	
	/**
	 * Constant indicates message to display number of Orders 	with data issues in this batch
	 */
	public static final String MESSAGE_TOTAL_ORDERS_DATA_ISSUES_BATCH="Total Number of Orders with data issues in present batch = ";
	
	/**
	 * Constant indicates message to display number of Orders which are not converted in this batch
	 */
	public static final String MESSAGE_TOTAL_ORDERS_NOT_CONVERTED_BATCH="Total Number of Orders which are not converted in present batch = ";

	/**
	 * Constant indicates the maximum files per folder
	 */	
	public static final int MAXIMUM_FILE_COUNT=500;
	
	/**
	 * Constant indicates the frequency for updating the error messages in table TBL_INSTALLBASE_CONVERSION_ERRORS
	 */	
	public static final int CONVERSION_ERROR_UPDATE_FREQUENCY=100;
	
	// Closed Sales Order Constants
	

	/**
	 * Constant indicates message when populating table TBL_CLOSED_ORDERS_BFR_13MONTHS starts
	 */
	public static final String MESSAGE_POPULATION_TBL_CLOSED_ORDERS_BFR_13MONTHS_STARTS="Started populating table TBL_CLOSED_ORDERS_BFR_13MONTHS with prior to 13 month old orders having valid warranty";
		
	/**
	 * Constant indicates message when populating table TBL_CLOSED_ORDERS_BFR_13MONTHS ends
	 */
	public static final String MESSAGE_POPULATION_TBL_CLOSED_ORDERS_BFR_13MONTHS_ENDS="Completed populating table TBL_CLOSED_ORDERS_BFR_13MONTHS with prior to 13 month old orders having valid warranty";
	
	/**
	 * Constant indicates message when populating table TBL_CLOSED_ORDERS_IN_13MONTHS starts
	 */
	public static final String MESSAGE_POPULATION_TBL_CLOSED_ORDERS_IN_13MONTHS_STARTS="Started populating table TBL_CLOSED_ORDERS_IN_13MONTHS with 13 month old orders";
	
	/**
	 * Constant indicates message when populating table TBL_CLOSED_ORDERS_IN_13MONTHS ends
	 */
	public static final String MESSAGE_POPULATION_TBL_CLOSED_ORDERS_IN_13MONTHS_ENDS="Completed populating table TBL_CLOSED_ORDERS_IN_13MONTHS with 13 month old orders";
	
	/**
	 * Constant indicates message when analyzing table TBL_CLOSED_ORDERS_IN_13MONTHS starts
	 */
	public static final String MESSAGE_ANALYZE_TBL_CLOSED_ORDERS_IN_13MONTHS_STARTS="Started analyzing table TBL_CLOSED_ORDERS_IN_13MONTHS";
	
	/**
	 * Constant indicates message when analyzing table TBL_CLOSED_ORDERS_IN_13MONTHS ends
	 */
	public static final String MESSAGE_ANALYZE_TBL_CLOSED_ORDERS_IN_13MONTHS_ENDS="Completed analyzing table TBL_CLOSED_ORDERS_IN_13MONTHS";
	
	/**
	 * Constant indicates message when analyzing table TBL_CLOSED_ORDERS_BFR_13MONTHS starts
	 */
	public static final String MESSAGE_ANALYZE_TBL_CLOSED_ORDERS_BFR_13MONTHS_STARTS="Started analyzing table TBL_CLOSED_ORDERS_BFR_13MONTHS";
	
	/**
	 * Constant indicates message when analyzing table TBL_CLOSED_ORDERS_BFR_13MONTHS ends
	 */
	public static final String MESSAGE_ANALYZE_TBL_CLOSED_ORDERS_BFR_13MONTHS_ENDS="Completed analyzing table TBL_CLOSED_ORDERS_BFR_13MONTHS";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_CLOSED_ORDER_LINES starts
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_CLOSED_ORDER_LINES_13_MONTHS_STARTS="Started populating table TBL_STAGING_CLOSED_ORDER_LINES with 13 month old ordes";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_CLOSED_ORDER_LINES ends
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_CLOSED_ORDER_LINES_13_MONTHS_ENDS="Completed populating table TBL_STAGING_CLOSED_ORDER_LINES with 13 month old orders";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_CLOSED_ORDER_LINES starts
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_CLOSED_ORDER_LINES_BFR_13_MONTHS_STARTS="Started populating table TBL_STAGING_CLOSED_ORDER_LINES with prior to 13 month old orders having valid warranty";
	
	/**
	 * Constant indicates message when populating table TBL_STAGING_CLOSED_ORDER_LINES ends
	 */
	public static final String MESSAGE_POPULATION_TBL_STAGING_CLOSED_ORDER_LINES_BFR_13_MONTHS_ENDS="Completed populating table TBL_STAGING_CLOSED_ORDER_LINES with prior to 13 month old orders having valid warranty";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_CLOSED_ORDER_LINES starts
	 */
	public static final String MESSAGE_ANALYZE_TBL_STAGING_CLOSED_ORDER_LINES_STARTS="Started analyzing table TBL_STAGING_CLOSED_ORDER_LINES";
	
	/**
	 * Constant indicates message when analyzing table TBL_STAGING_CLOSED_ORDER_LINES ends
	 */
	public static final String MESSAGE_ANALYZE_TBL_STAGING_CLOSED_ORDER_LINES_ENDS="Completed analyzing table TBL_STAGING_CLOSED_ORDER_LINES";
	
	/**
	 * Constant indicates message when retrieving total records to be processed from table TBL_STAGING_CLOSED_ORDER_LINES starts
	 */
	public static final String MESSAGE_RETRIEVE_TOTAL_CLOSED_ORDERS_TO_BE_PROCESSED_STARTS="Started getting total records to be converted from table TBL_STAGING_CLOSED_ORDER_LINES";
	
	/**
	 * Constant indicates message when retrieving total records to be processed from table TBL_STAGING_CLOSED_ORDER_LINES ends
	 */
	public static final String MESSAGE_RETRIEVE_TOTAL_CLOSED_ORDERS_TO_BE_PROCESSED_ENDS="Completed getting total records to be converted from table TBL_STAGING_CLOSED_ORDER_LINES";
	
	/**
	 * Constant indicates message when processing table TBL_STAGING_CLOSED_ORDER_LINES starts
	 */
	public static final String MESSAGE_PROCESSING_CLOSED_ORDER_STARTS="Started processing closed orders from TBL_STAGING_CLOSED_ORDER_LINES";
	
	public static final String MESSAGE_PROCESSING_OPEN_ORDER_STARTS="Started processing open orders from TBL_STG_OPEN_ORDER_LINES";
		
	/**
	 * Constant indicates message when processing table TBL_STAGING_CLOSED_ORDER_LINES ends
	 */
	public static final String MESSAGE_PROCESSING_CLOSED_ORDER_ENDS="Completed processing closed orders from  TBL_STAGING_CLOSED_ORDER_LINES";


	public static final String MESSAGE_PROCESSING_OPEN_ORDER_ENDS="Completed processing open orders from TBL_STG_OPEN_ORDER_LINES";
	/**
	 * Constant indicates message when getting charge names from table  XXCOFI.XXMCF_PRICE_ADJ_REASON_CODE starts
	 */
	public static final String MESSAGE_FETCH_CHARGE_NAMES_STARTS="Started getting charge names from table XCOFI.XXMCF_PRICE_ADJ_REASON_CODE";
	
	/**
	 * Constant indicates message when getting charge names from table  XXCOFI.XXMCF_PRICE_ADJ_REASON_CODE ends
	 */
	public static final String MESSAGE_FETCH_CHARGE_NAMES_ENDS="Completed getting charge names from table XXCOFI.XXMCF_PRICE_ADJ_REASON_CODE";
	
	/**
	 * Constant indicates message when populating table TBL_CLOSED_LINES_POS_PROVINCE starts
	 */
	public static final String MESSAGE_POPULATION_TBL_CLOSED_LINES_POS_PROVINCE_POS_STARTS="Started populating distinct POS store number to table TBL_STAGING_CLOSED_ORDER_LINES";
	
	/**
	 * Constant indicates message when populating table TBL_CLOSED_LINES_POS_PROVINCE ends
	 */
	public static final String MESSAGE_POPULATION_TBL_CLOSED_LINES_POS_PROVINCE_POS_ENDS="Completed populating distinct POS store number to table TBL_STAGING_CLOSED_ORDER_LINES";
	
	/**
	 * Constant indicates message when populating table TBL_CLOSED_LINES_POS_PROVINCE starts
	 */
	public static final String MESSAGE_POPULATION_TBL_CLOSED_LINES_POS_PROVINCE_POS_PROVINCE_STARTS="Started populating POS province to table TBL_STAGING_CLOSED_ORDER_LINES";
	
	/**
	 * Constant indicates message when populating table TBL_CLOSED_LINES_POS_PROVINCE ends
	 */
	public static final String MESSAGE_POPULATION_TBL_CLOSED_LINES_POS_PROVINCE_POS_PROVINCE_ENDS="Completed populating POS province to table TBL_STAGING_CLOSED_ORDER_LINES";
	
	/**
	 * Constant indicates message when getting store numbers and province names from table TBL_CLOSED_LINES_POS_PROVINCE starts
	 */
	public static final String MESSAGE_FETCH_POS_STORE_NUM_PROVINCE_PAIRS_STARTS="Started getting pos store numbers and province from table TBL_CLOSED_LINES_POS_PROVINCE";
	
	/**
	 * Constant indicates message when getting store numbers and province names from table TBL_CLOSED_LINES_POS_PROVINCE ends
	 */
	public static final String MESSAGE_FETCH_POS_STORE_NUM_PROVINCE_PAIRS_ENDS="Completed getting pos store numbers and province from table TBL_CLOSED_LINES_POS_PROVINCE";
	
	
	/**
	 * Constant indicates message that Closed Sales Order Conversion can't be performed 
	 */
	public static final String CONVERSION_NOT_PERFORM_CLOSED_SALES_ORDER= "Cannot Perform XML Generation for Closed Sales Order Conversion.";
	
	/**
	 * Constant indicates message that Open Sales Order Conversion can't be performed 
	 */
	public static final String CONVERSION_NOT_PERFORM_OPEN_SALES_ORDER= "Cannot Perform XML Generation for Open Sales Order Conversion.";
	
	/**
	 * Constant indicates closed sales order XSD
	 */
	public static final String CLOSEDSALES_XSD="YFS_importOrder_input.xsd";
	
	/**
	 * Constant indicates closed sales order XSD
	 */
	public static final String OPENSALES_XSD="OpenSalesOrder.xsd";
	
	/**
     * Constant indicates Y
     */
    public static final String FLAG_Y = "Y";
    
	/**
     * Constant indicates N
     */
    public static final String FLAG_N = "N";
    
    /**
     * Constant indicates closed orders document type
     */
    public static final String CLOSED_ORDER_DOCUMENT_TYPE = "0001";
    
    /**
     * Constant indicates closed orders name
     */
    public static final String CLOSED_ORDER_NAME = "convertedClosedOrders_Batch_";
    
    /**
     * Constant indicates closed order shipping note category
     */
    public static final String CLOSED_ORDER_SHIPPING_NOTE = "Shipping";
    
    /**
     * Constant indicates closed order packaging note category
     */
    public static final String CLOSED_ORDER_PACKAGING_NOTE = "Delivery";
   
    /**
     * Constant indicates currency
     */
    public static final String CURRENCY = "CAD";
    
    /**
     * Constant indicates charge category allowance
     */
    public static final String ALLOWANCE ="Allowance";
    
    /**
     * Constant indicates charge category Charge
     */
    public static final String CHARGE ="Charge";
    
    /**
     * Constant indicates charge category Discount
     */
    public static final String DISCOUNT ="Discount";
    
    /**
     * Constant indicates charge category Return
     */
    public static final String RETURN ="Return";
    
    /**
     * Constant indicates item type ALL
     */
    public static final String ALL ="ALL";
    
    /**
     * Constant indicates item type FloorModel
     */
    public static final String FLOORMODEL ="FloorModel";
    
    /**
     * Constant indicates item type As Is
     */
    public static final String AS_IS ="As Is";
    
    /**
     * Constant indicates charge name PRICE
     */
    public static final String CHARGE_NAME_PRICE ="PRICE";
    
    /**
     * Constant indicates tax name GST
     */
    public static final String TAX_NAME_GST ="GST";
    
    /**
     * Constant indicates tax name PST
     */
    public static final String TAX_NAME_PST ="PST";
    
    /**
     * Constant indicates tax name HST
     */
    public static final String TAX_NAME_HST ="HST";
    
    /**
     * Constant indicates tax name Optional service GST
     */
    public static final String TAX_NAME_OPT_GST ="OPGST";
    
    /**
     * Constant indicates tax name Optional service PST
     */
    public static final String TAX_NAME_OPT_PST ="OPPST";
    
    /**
     * Constant indicates tax name Optional service HST
     */
    public static final String TAX_NAME_OPT_HST ="OPHST";
    
    /**
     * Constant indicates home delivery truck ground
     */
    public static final String SHIPPING_METHOD_HOME_DELIVERY_TRUCK_GROUND ="000001_Home Deliv_T_GND";
    
    /**
     * Constant indicates DAYS
     */
    public static final String DAYS ="DAYS";
    
    /**
     * Constant indicates EACH
     */
    public static final String EACH ="EACH";
    
    /**
     * Constant indicates MIN
     */
    public static final String MIN ="MIN";
    
    /**
     * Constant indicates MCF Delivery SKU
     */
    public static final String MCF_DEL_SKU ="03511953";
    
	/**
	 * Constant indicates message when populating table TBL_OPEN_LINES_POS_PROVINCE starts
	 */
	public static final String MESSAGE_POPULATION_TBL_OPEN_LINES_POS_PROVINCE_POS_STARTS="Started populating distinct POS store number to table TBL_STG_OPEN_ORDER_LINES";
	
	/**
	 * Constant indicates message when populating table TBL_OPEN_LINES_POS_PROVINCE ends
	 */
	public static final String MESSAGE_POPULATION_TBL_OPEN_LINES_POS_PROVINCE_POS_ENDS="Completed populating distinct POS store number to table TBL_STG_OPEN_ORDER_LINES";
	
	/**
	 * Constant indicates message when populating table TBL_OPEN_LINES_POS_PROVINCE starts
	 */
	public static final String MESSAGE_POPULATION_TBL_OPEN_LINES_POS_PROVINCE_POS_PROVINCE_STARTS="Started populating POS province to table TBL_STG_OPEN_ORDER_LINES";
	
	/**
	 * Constant indicates message when populating table TBL_OPEN_LINES_POS_PROVINCE ends
	 */
	public static final String MESSAGE_POPULATION_TBL_OPEN_LINES_POS_PROVINCE_POS_PROVINCE_ENDS="Completed populating POS province to table TBL_STG_OPEN_ORDER_LINES";
	    
    /**
     * Constant indicates closed line status
     */
    public static final String CLOSED ="CLOSED";
    
    /**
     * Constant indicates SVG
     */
    public static final String SVG ="SVG";
    
    /**
     * Constant indicates SVG
     */
    public static final String DEFAULT_SVG_SKU ="03517364";
    
    /**
     * Constant indicates default SVG description
     */
    public static final String DEFAULT_SVG_DESCRIPTION ="Bedding Removal with Delivery only";
    

	/**
	 * Constant indicates the frequency for updating the messages in table TBL_CLOSED_ORDER_STATISTICS
	 */	
	public static final int CLOSED_SALES_CONVERSION_STATISTICS_UPDATE_FREQUENCY=100;
	
	public static final int OPEN_SALES_CONVERSION_STATISTICS_UPDATE_FREQUENCY=100;
	
	/**
	 * Constant indicates message when updating table TBL_CLOSED_ORDER_STATISTICS starts
	 */
	public static final String MESSAGE_PROCESSING_CLOSED_ORDER_STATISTICS_STARTS="Started updating closed sales conversion statistics messages to TBL_CLOSED_ORDER_STATISTICS";
	
	public static final String MESSAGE_PROCESSING_OPEN_ORDER_STATISTICS_STARTS="Started updating open sales conversion statistics messages to TBL_OPEN_ORDER_STATISTICS";
		
	/**
	 * Constant indicates message when updating table TBL_CLOSED_ORDER_STATISTICS ends
	 */
	public static final String MESSAGE_PROCESSING_CLOSED_ORDER_STATISTICS_ENDS="Completed updating closed sales conversion statistics messages to TBL_CLOSED_ORDER_STATISTICS";
	
	public static final String MESSAGE_PROCESSING_OPEN_ORDER_STATISTICS_ENDS="Started updating open sales conversion statistics messages to TBL_OPEN_ORDER_STATISTICS";
	
	/**
     * Constant indicates message when no sale lines to convert
     */
    public static final String MESSAGE_PROCESSING_CLOSED_ORDER_WITH_NO_SALES_LINE ="This order has no sales lines to convert.";
    
    
    public static final String MESSAGE_PROCESSING_OPEN_ORDER_WITH_NO_SALES_LINE ="This order has no sales lines to convert.";
    
    /**
     * Constant indicates message when no delivery lines to associate SVG
     */
    public static final String MESSAGE_PROCESSING_CLOSED_ORDER_WITH_NO_DELIVERY_LINE_FOR_SVG ="This order has no delivery lines to associate optional services.";
    
    /**
     * Constant indicates message when no sale lines exists for WTY line
     */
    public static final String MESSAGE_PROCESSING_CLOSED_ORDER_WTY_WITH_NO_SALES_LINE ="This order has WTY line which has no pointer to sales line.";
    
    /**
     * Constant indicates message when no sale lines exists for WTY line
     */
    public static final String MESSAGE_PROCESSING_CLOSED_ORDER_FURNITURE_WTY_WITH_NO_SALES_LINE ="This order has furniture WTY line which will not be converted and has no pointer to sales line.";
    
    /**
     * Constant indicates message when no sale lines exists for WTY line
     */
    public static final String MESSAGE_PROCESSING_CLOSED_ORDER_WTY_WITH_SALES_LINE_NOT_ON_ORDER ="This order has WTY line which has pointer to sales line not on this order or sales line not applicable for conversion.";
    
    /**
     * Constant indicates message when no sale lines exists for WTY line
     */
    public static final String MESSAGE_PROCESSING_CLOSED_ORDER_FURNITURE_WTY_WITH_SALES_LINE_NOT_ON_ORDER ="This order has furniture WTY line which will not be converted and has pointer to sales line not on this order or sales line not applicable for conversion.";
    
    /**
     * Constant indicates message when no sale lines exists for closed line price adjustment
     */
    public static final String MESSAGE_PROCESSING_CLOSED_PRICE_ADJUSTMENT_WITH_NO_SALES_LINE ="This order has closed line price adjustment which is not associated to any sales lines.";    
    
    /**
     * Constant indicates message when no sale lines exists for return line
     */
    public static final String MESSAGE_PROCESSING_RETURN_LINE_WITH_NO_SALES_LINE ="This order has return line which is not associated to any sales lines.";
    
    /**
     * Constant indicates message when line not applicable for conversion
     */
    public static final String MESSAGE_PROCESSING_LINE_WITH_INVALID_ITEM_TYPE ="This order has line of item type which is not applicable for conversion.";
    
	/**
	 * Constant indicates message when updating table TBL_OPEN_SALES_ORDER_ERRORS ends
	 */
	public static final String MESSAGE_PROCESSING_OSO_ERROR_ENDS="Completed updating open sales order error messages to TBL_OPEN_SALES_ORDER_ERRORS";

    /**
     * Constant indicates INFO
     */
    public static final String INFO ="INFO";
    
    /**
     * Constant indicates SVG
     */
    public static final String WARNING ="WARNING";
    
    /**
     * Constant indicates SVG
     */
    public static final String ERROR ="ERROR";
 
	/**
	 * Constant indicates default shipping method for closed sales
	 */
	public static final String DEFAULT_SHIPPING_METHOD="000001_Customer_P_CARRY";
   
	/**
	 * Constant indicates Salvage Line
	 */
	public static final String LINE_TYPE_SALVAGE = "SVG";

	/**
	 * Constant related to Return LineTypeId
	 */
	public static final String LINE_TYPE_ID_RETURN = "1005";

	/**
	 * Constant related to Primary Unit of Measure Days
	 */
	public static final String PRIMARY_UOM_DAYS = "DAYS";
	/**
	 * Constant related to Primary Unit of Measure furniture warranty
	 */
	public static final String PRIMARY_UOM_WRFEE = "WRFEE";
	/**
	 * Constant related to Primary Unit of Measure warranty
	 */
	public static final String PRIMARY_UOM_WTY = "WTY";

	/**
	 * Constant related to Primary Unit of Measure DEL
	 */
	public static final String PRIMARY_UOM_DEL = "DEL";

	/**
	 * Constant related to Primary Unit of Measure MINS
	 */
	public static final String PRIMARY_UOM_MIN = "MIN";

	/**
	 * Constant related to all other Primary Unit of Measure
	 */
	public static final String PRIMARY_UOM_EACH = "EACH";   
	
	/**
	 * Constant related to SubInventory Floor Model
	 */
	public static final String SUBINVENTORY_FLOOR_MODEL = "Floor Model";

	/**
	 * Constant related to SubInventory As Is
	 */
	public static final String SUBINVENTORY_AS_IS = "As Is";
	
    /**
	 * Constant indicates message that push to JMS queue can't be performed 
	 */
	public static final String CONVERSION_NOT_PERFORM_QUEUE= "Cannot Perform XML Message Push to JMS Queue.";

	/**
	 * Constant indicates JMS queue Log File Name
	 */
	public static final String JMS_QUEUE_LOG_FILE = "jmsQueue";
    	
	/**
	 * Constant indicates message that push to JMS queue started processing
	 */
	public static final String JMS_QUEUE_GET_DIR_NAMES_START_PROCESSING="Started getting child directories under batch direcory from where XML files will be pushed to JMS QUEUE - ";
		
	/**
	 * Constant indicates message that push to JMS queue started processing
	 */
	public static final String JMS_QUEUE_GET_DIR_NAMES_END_PROCESSING="Completed getting child directories under batch direcory from XML files will be pushed to JMS QUEUE - ";
	
	/**
	 * Constant indicates message that push to JMS queue started processing
	 */
	public static final String JMS_QUEUE_START_PROCESSING="Started process push to JMS QUEUE";
		
	/**
	 * Constant indicates message that push to JMS queue started processing
	 */
	public static final String JMS_QUEUE_END_PROCESSING="Completed process push to JMS QUEUE";
	
	/**
	 * Constant indicates message that push to JMS queue started processing
	 */
	public static final String JMS_QUEUE_PUSH_START_PROCESSING="Started XML file push to JMS QUEUE";
		
	/**
	 * Constant indicates message that push to JMS queue started processing
	 */
	public static final String JMS_QUEUE_PUSH_END_PROCESSING="Completed XML file push to JMS QUEUE";
	
	/**
	 * Constant indicates message that no sub directories were found under input batch
	 */
	public static final String NO_XML_SUB_DIRS_FOR_JMS_QUEUE="No sub directories with XML files for JMS QUEUE under directory - ";
	
	/**
	 * Constant indicates message that no xml files were found under particular directory
	 */
	public static final String NO_XMLS_FOR_JMS_QUEUE_UNDER_DIR="No XML files were found for JMS QUEUE under directory - ";
	
	/**
	 * constant used to find out furniture warranty sku
	 */
	public static final String INSTALL_BASE_FURNITURE_WTY_CONST1="05009999";
	/**
	 * constant used to find out furniture warranty sku
	 */
	public static final String INSTALL_BASE_FURNITURE_WTY_CONST2="83931594";
	/**
	 * constant used to find out furniture warranty sku
	 */
	public static final String INSTALL_BASE_FURNITURE_WTY_CONST3="05158888";
	/**
	 * constant used to replace furniture warranty sku
	 */
	public static final String INSTALL_BASE_FURNITURE_WTY_REPLACE_CONST1="43228253";
	/**
	 * constant used to replace furniture warranty sku
	 */
	public static final String INSTALL_BASE_FURNITURE_WTY_REPLACE_CONST2="83932785";
	/**
	 * constant used to replace furniture warranty sku
	 */
	public static final String INSTALL_BASE_FURNITURE_WTY_REPLACE_CONST3="43225689";
	
	/**
	 * constant used to indicate name of open batch directory
	 */
	public static final String OPEN_ORDER="OSO";
	/**
	 * constant used to indicate name of Closed batch directory
	 */
	public static final String CLOSED_ORDER="CSO";
	/**
	 * constant used to indicate name of Closed batch directory
	 */
	public static final String INSTALL_BASE="IB";
}